Overview: Sort Fields

Use this operation to prioritize the dataset fields, and then sort the values in the rows of the highest priority field in an ascending or descending order. The corresponding rows of the other dataset fields are moved according to the sorting criteria of the highest priority field. Where there are rows containing identical values in the highest priority field, the sorting criteria of the second highest priority field is considered. It is therefore important to ensure that the fields of greatest priority are listed highest of the selected fields, and that the ascending and descending order requested is stipulated for each field.

Properties

Category:	Transform
Performance risk:	Low performance risk
Knowledge required:	None

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	Yes
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	Yes
Does it modify the current dataset in any way?	No

Requirements

A dataset that contains at least one field.

Results

A new dataset is created, sorted according to the user’s selection.
All fields are retained in the new dataset. Those fields not selected to be sorted will be listed below the sorted fields.